A complete and total immersion in VBA. Learning to program and interact with Excel. A fun learning experience that balances practical tools of data and financial analysis with professional attribution.  We will cover absolute basics through the management of different objects and variants thereof. This course assumes no prior knowledge. It includes many lessons of real-world problems.  The course will cover the exciting world of Subs, Functions and Forms.

What am I going to learn from this course? The purpose of this course is to learn practical skills and knowledge in using Excel VBA. By the end of this course you will be able to create intermediate to advanced level Excel VBA real-world projects from scratch. You will be able to manipulate raw data in Excel with ease by designing Excel tools which save time, increase productivity and minimize the risk of making mistakes. What is the target audience for this course? This training program is for Excel users with no or little knowledge in Excel VBA programming. What is the course structure organized? This course consists of 6 sections. The first section is called “ Introduction to VBA” - we’ll have to get familiar with the basic concepts of VBA before we dive into the more advanced stuff. The second section is called “ Speed, Logic and VBA Exercises” – we’ll get familiar with using Excel worksheet and VBA functions, declaring variables, using loops, if-then statements, and also many different data manipulation techniques such as sorting data, removing blank rows, removing case sensitivity, applying borders or colors to a range of cells, etc. There will be many Excel exercises and examples in this section. Sections 3 to 6 including are all about using Excel VBA to create real-world projects from scratch: · Creating dynamic report of sales / payments in different currencies · Data matching project (by multiple criteria) · Sending emails project (using MS Outlook) · Creating a case tracking system (using MS Form Controls) What do I need in order to enroll in this course? You need a Microsoft Excel version installed on your device. I have used Excel 2016 for this course, but the examples in it should run on earlier versions of Excel as well. The newer version you have, the better. I am using Excel for Mac. Will this make any difference? There are certain differences between Excel for Windows and Excel for Mac, so some of the codes may not work properly on Mac. Do I need to have advanced level of using Excel before learning VBA? No, it's not necessary.

MS Excel is the integral part of MIS profession and one of the most useful Application for reporting and analysis. However to be successful in in this field only having the knowledge of MS Excel is not sufficient, the aspirant has to be well versed with Excel VBA as well. You may get to know about VBA at the time of learning and working with Macro itself. Macro recording enable the user to create a function it often requires. While the user records macros the Excel do a VBA programming for you. You may work on very advance level projects if you have got the knowledge of VBA. Our course curriculum has been considered as one of the most advance one. Download the content for more details. Moreover it enables the user to do what can be one in Excel itself but thousand times faster.

Go from Beginner to Microsoft Excel VBA Expert ! I'll take you step-by-step through engaging video tutorials and teach you everything you need to know to be able to use VBA to improve your work flow, save time and automate your current Excel projects. What differentiates this course from the other Microsoft Excel VBA & macros courses? It includes: Over 50 Microsoft Excel VBA & macro examples . These are solutions my clients have needed through the years. They are likely to be useful for you too. Using the right VBA syntax is the most difficult part. An important topic which isn't covered enough in other VBA courses. In this course you understand why you write things in certain ways. Create 3 Complete Excel VBA Tools. We go from idea to final product and cover each step. Over 100 pages of documentation (including useful code) so you can easily refer to it when in need. Simple explanations for complex concepts. High quality video and different delivery methods to keep things interesting. Lots of ideas to automate your current tasks. Learn from Google or from this Course? I've been there! I first learnt VBA from Google. It was truly a light-bulb moment, when I realized that Google has some answers - it could give me some of the code I was looking for - but there two things missing: The WHY - why does the code work in one situation but not another. Structure - topic sequence, real-case examples, workbooks, documentation. Don’t waste your time Don't waste your time on poor quality videos and confusing explanations. In this Excel VBA course, complex topics are taught in a simple way by an instructor with 17 years of experience. The content has been carefully crafted and clearly organized. The videos are high quality and include animations to emphasize points. Most importantly you learn VBA by doing. "I have already tried some VBA classes but so far I was never able to apply what I learnt to my own work. This course is different. I have already used some of the techniques Leila is teaching and applied it to my work files. I was able to reduce manual work for me and my colleagues by creating my own macros from scratch. Highly recommended!!!" -- Randy Taylor "Leila is the real deal... there are many VBA courses on Udemy (some of which I've taken) that merely demonstrate the functionalities. Leila explains the important foundation concepts and how the model is set up allowing you to truly create VBA code from thought rather than copying and pasting from various places. Her class is professionally constructed, with resources and content for each lecture, practice content for you to try things yourself and good Q&A opportunities to answer specific questions. Trust me, this is the course you want to take." -- Justin Fazzio What you can look forward to in this course: Understand how to use the right syntax in VBA Useful Excel VBA codes you can directly use for your work Use the macro recorder for simpler tasks and improve the code Working with the Visual Basic Editor Debugging tools and error handling methods Different ways to reference ranges and cells Different methods to loop How to work with data types PivotTables in Excel using VBA Importing data from other files and exporting data to text files Interacting with other applications (Word, PowerPoint, Outlook) ActiveX and Userforms to enhance the Excel interface Basically all the knowledge you need to automate tasks in Excel

The course provides a solid foundation in Excel VBA. Using Excel VBA will extend your knowledge of recorded Macros and provide you powerful skills to automate Excel. This course explains how and where Macros can be useful in Excel and how to use Excel for as much of the “heavy lifting” as possible.

Course is focusing on basic level developers who know arrays. loops and variable pretty well and now want to take their knowledge to next level. From designing to programming and what things to be kept in mind while making user-forms. Collection loops structure in User-forms and their use practically. User-forms are very important part of VBA and one cannot be known as a great programmer if he or she does not know userforrms. This is not just a basic level information tutorial on FORMS but you shall see here loops, if functions, variables use and collections loops is applied . After-all. there is nothing better than practical learning so i have great MIS Projects as well for you. Many good short projects for you on user forms. Combobox,Listbox,textbox,labels,command buttons,date time calendars,frames - everything discussed from sctrach Use of change event, click event, initialize event,close events Create Move next button in forms to see the data one by one coming from excel Some projects and assignments with ready made codes is added as well.

This course will provide you with essentials about Visual Basic Applications (VBA) Excel for Finance. VBA is the programming language of Excel and is a fast programming language. When correctly mastered, it can automate almost every task that is required in Banking and Investment Banking. By taking this class, you will see that getting a job in investment banking is not just a matter of luck, but of technique and forward thinking. This course is best suited for university students who are studying business, finance, accounting, economics or any other finance related programmes. This course is also for anyone who is interested in knowing more about the Banking and Finance world, and to know about necessary skills to acquire to get into these sectors. No prior technical knowledge is required. The course covers: Fundumentals of VBA : Functions, Sub, Variables, Loops, Conditions. Real life applications that are used in Banks today Build pricers for options and bond Create Userforms and top-notch charts Link your VBA application to a database Understand the concept of Object Oriented Programming Why should you take this course? You are a finance student. You are really struggling in finding a good and challenging position in Banking. You would like to start your career with a great asset on your resume and you are motivated to reach that goal. You are a banker facing issues with repetitive tasks to run on a daily basis and you want to learn how you could automate all of those tasks in a single process. You are already a banking employee, but you are working in a department that does not fit your ambitions, and you would like to join a more challenging department such as front-office, and work in the exciting environment of the trading room. In order to do that you need to prove that you can bring value to the team. With this course, you get everything you need to be able to quickly design performant VBA applications.

This is an introductory course on how to program Excel using VBA macros. You will learn to automate and extend the Excel environment to supercharge your Excel models, automate routine tasks, customize your user interface, and manage large quantities of data. This course is based on the instructor's semester-long college courses which have produced thousands of graduates in the fields of business, finance, health care and public policy. Designed for busy professionals who need to take their Excel abilities to the next level, you will not waste time on topics which you are unlikely to use, and you will receive extra attention to the often confusing or overlooked details that will make the most difference to your ultimate understanding. Over 8 hours of instruction!

A Management Information ystem (MIS) provides organisation with the information they require in an organised manner to take upon management and crucial decisions. MIS tools and knowledge is very important nowadays. There is a very high demand for MIS Professionals in the market and the manpower supply of it is very less because of the obvious reason that the skill-sets required is not a part of any academic curriculum. A professional training in it hence becomes mandatory. This training will endow every student with the skill sets required to be a successful MIS professional. Our course curriculum comprises of all the important aspects requires in the real world to get the job done in MIS. The student will get the enhance knowledge in Data management, Reporting and Analysis through MS Excel, MS Access & RDBMS. Moreover training will be given on the most demanding technology , which is MACRO -Automation.

VBA was considered a dead language until new functionalities and objects have been made available to enable data exchange between MS Office products and the Web. Today VBA offers functions to send HTTP requests , receive HTTP responses and parse the final results using technologies and objects e.g. DOM , XML parsing , JSON parsing , XML XPath , VBA Regular Expressions , ADODB connections to SQL Server and mySQL Databases , generate Web Browsers to embed into VBA forms and much more. Before into details I have included some lectures for those that are new to understand and get to know Excel, Visual Basic for Applications (VBA) and HTML . The students will learn the following in this course: HTML DOM HTML editing tools Open a Web page in VBA Create HTML Tables with from Excel Worksheets with VBA Create HTML Files with a Table of Contents based on Cell Data Download File from Website Using Excel Scraping data from website using vba Get data in an HTML table and display in an Excel file Get all the data in an HTML table and display in an Excel file VBA Code – To extract data – From website to Excel Macro with ServerXMLHTTP Scraping a website HTML in VBA using the HTMLDocument object Read data from a website using VBA web query Import Website data to Excel Embed a browser in an Excel VBA form Identify information on a Web Page and display it in human readable way Processing human friendly messages Generate machine-friendly messages Import JSON to Excel Import an XML file into Excel Get data from the web Use the InternetExplorer Object to get Data from the Web Use the InternetExplorer object to get elements of an HTML table Retrieve single HTML elements using the InternetExplorer object Parse and submit an HTML form using the InternetExplorer object Trigger events of elements using the InternetExplorer object Click on a button and trigger the associated event using the InternetExplorer object Enter data dynamically into an HTML form using the InternetExplorer object Use XMLHttp to send HTTP requests, receive HTTP responses and parse the content Use ServerXMLHttp to send HTTP requests, receive HTTP responses and parse the content Using ServerXMLHTTP to GET XML results from a Web page Using ServerXMLHTTP to POST XML to a Web page Providing authentication info via msxml2.ServerXMLHTTP (use JustGiving API) Scrape html by element id, name after response using msxml2.ServerXMLHTTP Save MSXML2.ServerXMLHTTP Response text is an HTML Page Extracting data from the response of a serverXMLHTTP request Extract a table of data from a website using a VBA query Pull data into Microsoft Excel with Web queries Import HTML content in Excel with Query Tables Import HTML table with Web Query Invoke a SOAP Web Service from custom VBA Code Do a SOAP Request in VBA Use VBA to send XML to WSDL Create a SOAP Request/Response using XML from VBA Get Http Request In Excel Vba Build a VBA App from calling an API Make REST call with VBA in Excel: WinHttp Send HTTP requests with VBA from Excel with WinHttp Get Http Request In Excel Vba with WinHttp Get JSON Response with WinHTTP in VBA Install and configure SQL Express Server and the Management tool for testing Connect to a remote SQL Server DB With VBA & ADODB Use Excel VBA to Query a SQL Server Database Install and configure a mySQL Database for testing Connect to remote MySQL Database Connect to MySQL database in Excel with VBA and get the data Send HTML Email from Excel using VBA Show RSS Feeds in Excel Read RSS feeds from VBA create an rss feed with Excel VBA Get Data from Bing Search and display the results using DOM Display google maps on a UserForm Calculate durations and distances of itineraries from Google Maps with VBA Retrieve Address Geocoding with VBA and Google Maps Parse strings from HTML code via VBA code using RegEx ...